SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294022 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294022 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939156,974086,559078,841704,107866,496932,459542,826669,799740,212102,707338,553312,95247,426484,612925,189506,867843,140476,31848,300524,36841,171754,536402,633148,326337,967698,175057,85684,434662,691439,85371,833573,347705,304631,468313,998619,571184,413624,458859,973786,335322,811698,174278,790009,492468,20140,765353,474796,9122,757147,854964,68871,641778,663853,538060,1013995,669839,88331,893276,933465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000721s ]