SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002015s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54485 LIMIT 1 [ RunTime:0.000639s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54485 [ RunTime:0.005806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (241981,766080,590679,202467,505525,647234,352600,408672,268940,384094,357623,575479,811791,432213,771821,433173,308513,680014,290562,332691,437586,6871,1691,131957,100889,609237,391803,708154,575148,708213,645315,676223,782622,436025,231829,968123,1026571,662684,869979,25450,317503,692002,716714,95583,571233,370871,1016271,248834,791404,339090,928196,53627,272456,669969,559383,82146,423299,662460,909880,685738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54485 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54485 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]