SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407658 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407658 [ RunTime:0.001858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3086,496524,298858,1003130,61166,428141,662474,436220,251421,400252,1023603,64083,811278,717277,1012337,569547,754959,846182,218507,928178,506959,406707,472650,314564,245882,107873,255820,411516,218768,38342,378210,1012022,472526,586865,612131,203303,890612,717833,592825,319277,1028230,215287,604129,1024625,327070,616115,669470,364905,923106,132846,65160,555780,945252,605817,443996,299655,302449,559349,605328,611947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407658 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407658 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]