SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548620 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548620 [ RunTime:0.001906s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519910,872357,733675,277380,720145,515663,275969,955328,60068,551256,994218,623884,767082,871968,338482,983720,606246,667275,246554,820519,446857,67182,741166,571385,165752,839240,693047,1032689,893268,136556,626954,4393,813304,1000922,424491,605221,1035874,857214,481589,727453,21969,911480,809591,607435,260152,804080,134717,681631,412270,9467,871756,542038,823723,603857,595328,550764,1035161,858995,310020,666066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002778s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001404s ]