SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901083 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901083 [ RunTime:0.001857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275147,894220,401640,944267,51505,225585,806059,92153,616195,769281,646907,416591,204508,579736,433406,1024420,95217,555873,868903,524200,43973,879131,588541,213690,620184,851250,736378,241130,358762,775052,38018,656840,920944,914916,374263,853760,29135,617270,595918,322674,908335,398528,716990,976506,168320,575583,546876,1040923,805527,75462,982710,354922,125457,122072,52616,746428,971923,452463,187220,817539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]