SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431004 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431004 [ RunTime:0.002565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316477,740098,453250,843635,909925,465937,836588,812397,924584,593234,484087,343992,82727,112894,880558,683110,712063,550150,656744,266292,554965,300581,615500,273927,157716,486255,399797,897770,142705,1027794,938431,904743,702435,395586,648614,932482,42476,360956,967213,86316,237958,211609,878885,519356,24921,229454,599071,607754,570506,720002,678511,359911,43050,27295,350186,515974,214601,247705,440552,406330) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]