SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406010 LIMIT 1 [ RunTime:0.000481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406010 [ RunTime:0.002312s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100831,224523,1015310,809699,909279,753831,316846,461278,371986,556096,345327,42288,397024,91990,719521,671427,340092,539050,802098,892296,764169,193566,231221,3187,489500,890174,675367,755512,454902,220894,477676,936971,924370,647060,755120,145921,988278,791247,522882,509269,743465,470847,553439,845217,350760,308585,253246,201720,490004,746559,430434,535754,201470,584094,488159,933473,1026819,212230,619081,820702) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]