SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 94140 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 94140 [ RunTime:0.002506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (875989,358930,458642,1021633,606448,770719,204871,173812,707966,589372,794550,509739,603254,341368,543210,217597,613143,885885,584666,1031807,1036395,1016611,391955,1008923,512089,74384,735264,644434,185302,1025163,471299,814795,667915,513181,834454,284178,248433,112561,481801,743950,687757,32005,879486,283947,309914,255633,353342,902918,501803,1021194,515834,674455,630469,128979,794955,95969,8070,237775,470567,300439) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 94140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 94140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]