SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001936s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 18810 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 18810 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013156,377591,961579,954821,660112,739765,242651,198851,244764,345397,919202,236484,435897,51139,21835,462710,442795,98376,833848,99159,268828,314028,873835,398099,332105,675096,286174,1034333,463435,379486,744750,602839,629375,582020,323382,312189,862231,479288,456319,194307,727020,821214,2377,191366,100244,890361,474189,63636,67925,114755,864582,93783,962483,401319,510548,333477,68975,407771,5500,158572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 18810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 18810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]