SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002064s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504512 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504512 [ RunTime:0.002128s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (168224,982386,300805,21321,106714,647050,839004,336635,893956,891624,960685,786819,801684,245071,61030,928651,970568,46073,153083,1025303,605822,11937,480837,601128,70568,749899,371602,719706,504420,797058,921942,243073,973003,376692,1017428,930294,81040,713045,531705,973455,105336,172645,229926,224025,535679,690513,1045944,771030,448813,376905,407640,470535,567487,45802,914202,6703,799331,916078,290859,472530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]