SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420584 LIMIT 1 [ RunTime:0.000916s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420584 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (959297,333791,231929,48568,318578,828622,937942,409480,82197,532126,164132,11050,749596,329275,974087,174838,60877,174308,250597,541071,194482,873481,963011,676703,1039965,717430,405648,740433,314767,1038989,567444,885496,939631,967068,61271,335648,627871,803011,784214,306979,242776,605589,155301,232316,20560,614551,285523,1000513,659311,550544,970783,704361,971372,200689,908379,25580,716747,808200,532952,899674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]