SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538022 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538022 [ RunTime:0.002196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022569,403607,286663,382152,615460,14468,137059,858714,989925,1018693,994191,237852,630913,1004814,334239,945706,43731,1047850,686515,442924,563984,1031980,877940,212052,413131,574155,849555,852826,438171,1029208,589237,923928,6930,362972,960458,750023,161781,469253,491770,901193,175647,145139,480219,1034072,851426,342785,274096,728398,22917,370873,951940,559189,254713,156604,847733,281499,234342,150168,13952,813006) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]