SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 22299 LIMIT 1 [ RunTime:0.010089s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 22299 [ RunTime:0.005688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417151,343476,598060,235072,94464,106856,791731,415743,437746,792380,271313,950867,500446,210409,474090,706602,371473,104370,651768,8094,274697,38111,235555,264716,624752,1011672,271283,263412,920808,302384,118988,131135,739351,265297,861845,990722,655345,330227,266135,700220,396655,457676,509396,167400,661782,845875,794691,907771,851049,521304,629412,688925,176510,725338,466994,978396,377822,72409,366422,300276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 22299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 22299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000798s ]