SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380661 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380661 [ RunTime:0.002418s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410984,411655,749127,61462,185596,679203,476767,694277,248386,639067,341111,292128,401320,770831,179751,992321,107813,40649,101529,662537,590333,917202,837484,441249,711674,1007272,170022,491003,58068,576045,336273,1016516,482929,163521,561831,571009,179228,281364,51716,148631,769926,336393,601598,446658,235063,359671,553103,1002341,440501,900838,734639,727563,346330,932824,184368,675431,921135,664424,858007,50313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380661 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000673s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380661 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]