SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001458 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001458 [ RunTime:0.002118s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621081,887776,823605,811390,730239,603493,515954,605517,405402,47711,436520,636352,500076,618995,174796,912268,363194,66752,644851,698718,165439,230928,841582,317266,510356,787327,781651,703274,388643,538292,169942,1031875,172031,168089,710117,918249,665820,842882,339365,1034127,108840,768734,626217,980731,896202,504962,1013087,590818,492854,47325,86669,831064,559709,684825,951199,869737,349717,775142,271802,432453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]