SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001468s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005440 LIMIT 1 [ RunTime:0.001485s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005440 [ RunTime:0.002194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (730946,927223,486321,232897,247816,1024471,870891,668191,1007950,851886,436689,1001213,653520,581838,917731,769102,856235,390885,495985,837636,821018,554210,150187,180129,354954,267984,829080,822932,695282,56030,1025798,697317,145445,107970,207894,693815,867798,803349,77627,590481,646102,493044,756018,243588,613924,426756,424026,814747,520472,967603,84470,207821,161765,433320,564593,25185,547180,964858,999479,670892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003821s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003751s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001132s ]