SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467937 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467937 [ RunTime:0.001915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40194,440657,960916,488241,583853,934158,276722,591774,262388,204773,37509,805100,206957,600482,229410,569264,305248,473925,351051,291513,468331,827556,254938,40004,999127,868085,341267,540698,276843,709970,790975,211213,806700,367294,603119,998991,846878,490174,179798,672708,979116,584113,61671,212230,748485,629913,120410,156587,675708,563546,884015,914669,245056,483289,779953,188765,994709,816277,159565,42026) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467937 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467937 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]