SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575617 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575617 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (981075,21751,68728,507129,914523,488968,759880,949525,52345,697322,320374,1000803,24522,492501,391966,900039,716371,669588,298155,1042052,198281,51607,138642,766708,325923,998261,291024,603794,923997,341332,898218,37928,281041,337591,17730,381575,718014,703300,452287,134409,686399,341550,259915,438027,533673,426669,355093,455155,432431,416585,37756,688331,575578,496503,942965,300150,372671,107436,271296,27099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575617 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575617 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]