SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477245 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477245 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033598,12131,510233,556858,961706,906792,334232,124172,862069,506470,716300,15924,455353,835199,255213,693507,712678,265115,200590,774251,6495,223027,479595,942929,324406,401753,613401,771720,1008016,467253,822235,521133,310128,984021,43943,13227,912693,43861,887356,291361,502600,625898,589085,713668,111058,266339,976205,363385,1037244,705642,187802,507033,718302,328943,250300,767755,760548,929655,761994,266955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477245 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477245 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]