CodePudding user response:
Is anyone here? To reply theCodePudding user response:
Itself is not quick, slow loading for the first time, after all is a read cache, so fast,Best can send look at the content of the view,
CodePudding user response:
SELECT` meters `. ` instrument file number ` AS ` instrument file number `,
` dfelecmeterparameter_single `. ` equipment line number ` AS ` ` of line number,
` meters `. ` change ratio coefficient ` AS ` ` ratio coefficient,
` meters `. ` logo ` AS `'s table, table `,
` meters `. ` installation location ` AS ` ` installation position,
` dfelecmeterparameter_single `. ` sell electricity number ` AS ` sell electricity `,
` dfelecmeterparameter_single `. ` sell electricity state ` AS ` ` sell electricity state,
` rooms `. ` housing file number ` AS ` housing file number `,
` rooms `. ` housing name ` AS ` housing name `,
(
CASE
WHEN (substr (` dfmetertype `. ` functional description `, 14, 1)='1') THEN
14
WHEN (substr (` dfmetertype `. ` functional description `, 3, 1)='1') THEN
3
END
) AS ` ` cancellation instructions,
(
CASE
WHEN (substr (` dfmetertype `. ` functional description `, 29, 1)='1') THEN
29
WHEN (substr (` dfmetertype `. ` functional description `, 30, 1)='1') THEN
30
WHEN (substr (` dfmetertype `. ` functional description `, 22, 1)='1') THEN
22
END
) AS ` ` meter reading instruction,
` rooms `. ` inputting time ` AS ` ` inputting time,
` meters `. ` instrument type ` AS ` ` instrument types,
` meters `. ` instrument marked ` AS ` annotation `,
` meters `. ` card number ` AS ` card number `,
` users `. ` household names are ` ` AS ` household name,
` users `. ` resident status ` AS ` resident status `,
Whether ` meters `. ` ` AS whether ` ` opening an account opening an account,
` meters `. ` ` account opening time AS ` ` account opening time,
` meters `. ` type number ` AS ` type number `,
` dfelecmeterparameter_wholemeter `. ` device type ` ` AS ` equipment types,
` meters `. ` card number ` AS ` card `,
` rooms `. ` ` number AS ` ` number,
` meters `. ` price coding ` AS ` price coding `,
` price `. ` prepaid price ` AS ` prepaid price `,
File number ` ` users `. ` residents AS ` resident file number `,
` meters `. ` meter number ` AS ` meter number `,
` dfelecmeterparameter_single `. ` factory number ` AS ` factory number `,
` users `. ` username ` AS ` username `,
` users `. ` password ` AS ` password `,
Id ` users `. ` ` id AS ` `,
Whether ` dfelecmeterparameter_single `. ` push ` AS ` whether to push `,
` dfelecmeterparameter_wholemeter `. ` address ` AS ` address `,
` dfelecmeterparameter_wholemeter `. ` protocol type ` AS ` protocol type `,
` dfelecmeterparameter_single `. ` monovalent ` AS ` monovalent `,
` dfelecmeterparameter_single `. ` price change ` AS ` price change `,
Prepaid ` ` meters `. ` software AS prepaid ` ` software,
` meters `. ` total purchasing power ` AS ` total purchasing power `,
` rooms `. ` xiaoqu_id ` AS ` xiaoqu_id `,
` rooms `. ` loudong_id ` AS ` loudong_id `,
` rooms `. ` room_id ` AS ` room_id `,
Whether ` meters `. ` ` card account AS whether ` ` card account,
Service ` price `. ` ` service AS ` `,
` price `. ` ` AS the utilities ` utilities `
The FROM
(
(
(
(
(
((` rooms ` JOIN ` meters `) JOIN ` price ` ON ((` meters `. ` monovalent coding `=` price `. ` monovalent coding `)))
Check the JOIN ` dfelecmeterparameter_single ` (` meters `. ` instrument file number `=` dfelecmeterparameter_single `. ` instrument file number `))
)
Check the JOIN ` dfelecmeterparameter_wholemeter ` (` dfelecmeterparameter_single `. ` factory number `=` dfelecmeterparameter_wholemeter `. ` factory number `))
)
JOIN ` dfmetertype ` ON (` dfelecmeterparameter_wholemeter `. ` device type `=` dfmetertype `. ` type number `))
)
The JOIN ` roommeter ` ON (((` meters `. ` instrument file number `=` roommeter `. ` instrument file number `) AND (` rooms `. ` housing file number `=` roommeter `. ` housing file number `)))
)
JOIN ` users ` ON (` rooms `. ` housing file number `=` users `. ` housing number `))
)