SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 240208 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 240208 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311605,981910,573297,711892,443363,109213,11971,448529,245222,72015,844785,297752,776840,362683,21967,1033676,496432,322941,95468,153710,769507,129875,180841,200786,762791,567088,794926,758392,1009406,30872,754077,11325,861776,965657,112196,50718,876748,402272,368844,209169,651762,745044,443260,1008362,270460,286746,685719,1044628,617464,479100,735901,862893,731614,907761,210396,548323,876624,410086,821099,805486) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 240208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 240208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000790s ]