SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101012 LIMIT 1 [ RunTime:0.001610s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101012 [ RunTime:0.004501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038597,279239,360337,602893,328626,228928,799394,18020,915333,155035,640606,137129,725724,178830,860413,983772,648263,496806,512099,745694,884303,24071,1034453,472569,534568,276833,362834,280700,667772,298024,45260,433369,1025740,126300,187102,220413,564675,362061,169366,326059,269710,307086,582831,825906,973465,287387,140685,880016,806381,629788,780698,827938,690445,54957,975397,840367,329996,825897,541205,32229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]