SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503272 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503272 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005693,210424,5481,509998,1016655,455064,159232,223126,136596,212939,870649,561814,639230,551762,542370,694779,496238,355387,717269,819991,135407,774945,330322,378914,958409,271238,1025931,1015206,918136,625679,908201,155228,767655,947772,53102,21075,992254,410999,537051,659941,506010,595505,7314,912353,791054,597889,1010095,272812,166292,846280,742655,514362,604776,784956,428539,384868,588249,1000460,594339,105676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]