SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 364513 LIMIT 1 [ RunTime:0.000525s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 364513 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149439,647303,522540,681891,850687,713342,650810,954787,174916,1008582,854051,941485,5523,545379,335638,1032218,559854,534970,122331,649649,245720,458133,150357,199072,119831,55775,776318,165757,406598,344688,1013221,643774,919190,850957,982804,1005952,477208,44275,6223,958798,553517,11265,176266,229188,430805,536065,909594,593505,1023573,207242,657463,59136,453167,129655,387743,137449,706615,286104,494022,998488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 364513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 364513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]