SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30167 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30167 [ RunTime:0.002047s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505170,434400,502622,347099,183804,152324,451908,164152,108810,359070,898001,808731,246386,882735,40993,1033488,982212,484564,313884,248167,341663,1009954,747717,651298,636221,440122,232704,241535,385207,914531,92769,132110,121915,575140,397609,535952,43111,150345,687045,427451,726556,590204,151090,829887,534415,369721,300523,984230,689473,74372,565414,342421,31533,819910,986775,476438,805073,73312,714218,943531) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30167 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30167 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]