SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401651 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401651 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522270,474558,731084,733998,61046,816104,43439,357828,825191,425197,867678,789325,933382,251938,310749,1006723,300731,670707,1019680,116109,513331,439853,91278,717178,233561,633140,321933,956050,106768,141060,380081,415266,359142,689345,172614,62050,611169,431254,660890,284902,448792,85555,728754,190576,490383,266397,646661,597355,830682,453711,579246,430776,370162,178956,25267,570837,327925,130451,334808,101379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]