SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 167601 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 167601 [ RunTime:0.003872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009899,664768,331547,384287,674586,696123,577230,903352,626565,329006,973893,563403,834643,923109,500449,861529,1038477,111485,957914,902912,719772,455054,48040,928346,83857,215473,870538,1040498,370416,245981,531610,564230,378950,975402,70676,681753,216846,281332,418623,250553,253170,1039935,47588,185917,295294,1038187,260121,849707,576309,116786,553745,792013,758606,232171,464137,503153,151962,348188,699019,888920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 167601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 167601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]