SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338545 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338545 [ RunTime:0.004311s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654943,972941,5671,588102,246603,802447,500177,365458,329215,926157,555738,881697,684291,540721,1034505,822374,696510,992702,451390,722381,627379,417071,938540,975375,231427,665400,706076,920329,779855,597214,658081,538038,492938,218477,141977,718433,759285,649717,133150,529082,734347,263007,565772,958525,287545,135330,644901,619459,301605,936851,742875,608864,144299,611353,269270,672131,876516,759230,583205,875660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]