SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406648 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406648 [ RunTime:0.002960s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455184,455667,314880,329366,767808,57206,584486,111165,742149,1020349,466302,400525,936750,1036411,685615,266330,299475,514554,689928,783466,396654,853032,1000563,31119,169680,689251,778995,468799,606746,681729,199233,742660,488322,598351,459142,95284,722744,95590,585459,1009258,445224,680567,235619,1006511,658021,217481,44408,412391,879575,234223,357356,163041,401962,531720,510506,585294,745508,122742,80641,102020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]