SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533591 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533591 [ RunTime:0.002719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239618,31288,538221,1022355,391223,298218,813193,458361,603039,508171,294154,456833,638109,851617,215889,1041102,625248,131419,82476,150773,339616,686756,133402,483693,9753,155395,325923,1025287,360479,723372,933126,51253,8492,778049,153991,168326,255316,1045769,198432,847707,830551,988149,675635,569939,1085,852184,881179,462366,778145,550747,857690,763758,491787,583725,227460,7268,454127,977433,417428,924217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]