SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 231180 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 231180 [ RunTime:0.001888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343250,674890,240490,282000,972757,159366,476098,318259,578333,575196,581153,117590,197329,1018205,304874,705289,209569,990699,808988,393621,521829,427783,163347,166897,122018,587429,713611,420995,339732,368231,180483,175013,841930,156944,50083,228684,3042,60769,55632,33882,367295,797013,113104,949365,55922,328493,399472,575458,373813,918988,271092,648993,169058,152585,526962,123725,230838,188781,782240,525102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 231180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 231180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]