SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38109 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38109 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810028,566982,326830,809553,452324,152820,760525,563781,429791,145714,790002,330410,142832,556781,86100,769144,534890,605318,995535,792673,700608,438510,873516,394911,239900,245102,909380,489220,1021011,719562,97618,384600,937535,368321,1001321,1011126,776619,295472,13138,613266,755893,179091,203803,868884,650264,933019,822682,589548,656395,753286,994828,1039102,701600,290646,349930,156350,830803,135775,284716,94679) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]