SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445041 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445041 [ RunTime:0.002262s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (960846,349781,492686,156799,937529,524607,1014206,1033528,557837,579377,406990,748207,1048474,1015681,608151,924031,892063,927225,531892,997487,199096,367517,837504,789344,960275,791941,721534,217786,676033,229254,247873,964008,373354,361132,192941,684683,170328,354209,227713,230622,835269,531190,74398,786576,644340,226712,816115,341656,1048251,369226,422559,413683,205056,563054,672742,832597,14785,694913,522558,419864) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]