SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001601s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293590 LIMIT 1 [ RunTime:0.000623s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293590 [ RunTime:0.003496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (645943,481197,1039576,444747,228645,277090,181441,887710,931299,282731,33844,274639,436325,232189,549471,762317,30920,579012,575374,227662,882292,4371,196681,330883,41714,263705,251421,272566,667828,283292,270964,798800,154733,696902,976929,306907,542782,161344,331076,344467,576589,23307,936841,1027015,95029,278772,873668,325683,331780,263163,852433,951952,273610,110196,337981,434809,625656,435610,352591,889830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]