SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292010 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292010 [ RunTime:0.001957s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311870,537271,159033,903401,945577,130588,1026233,658957,65692,69804,122404,1024661,546717,97857,433685,694451,926015,801829,876540,178931,363,490850,904175,639733,759173,778101,819358,246471,937330,864592,749723,653408,602583,264388,351052,518682,893668,477302,912054,780363,640995,71909,1008377,215759,583598,829832,381698,259980,649224,441821,250781,127903,1041151,60541,199543,231278,492856,366087,442731,381049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]