SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54885 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54885 [ RunTime:0.001705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623504,488717,423231,620322,873589,593443,704847,165962,1024349,910251,555550,684162,568945,341935,35748,737806,147660,513925,941963,586133,987834,1015314,406833,27878,489569,87786,844038,1011199,870628,629397,325914,583078,167736,406923,410071,982682,73767,952996,28070,650945,913684,416183,465114,749161,1021665,367205,180924,18263,840791,179249,670680,527476,127866,173276,507950,170895,661283,632689,1016017,33902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54885 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54885 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]