SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417408 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417408 [ RunTime:0.001538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (387441,1027909,140013,622113,582128,493541,718151,727775,408627,107071,830327,861347,849007,586852,560317,235543,52717,549423,864739,643785,786589,708901,424651,997816,617084,11926,500498,368559,747790,550924,975934,810418,585395,167028,1045450,799567,438960,964481,553457,700100,579249,943537,857796,71295,817475,368957,344507,4280,128754,453508,494225,964690,875402,339945,382080,929140,474013,666065,749801,819854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417408 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417408 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]