SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019775 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019775 [ RunTime:0.002046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (22820,636548,25686,677202,798859,1028933,164111,133556,418244,218521,345445,31780,19742,540010,455465,374659,188706,408423,374389,769464,594200,968323,804606,218941,193630,780630,863233,429697,612196,699003,54399,1034676,228824,478702,962451,681762,67868,1048186,586071,717552,483455,808126,292152,734172,1027468,969038,702300,968920,881038,289918,444235,1033334,708905,478004,135556,750154,916932,487659,863689,126741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003792s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019775 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019775 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000951s ]