SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455435 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455435 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819332,753931,712653,819931,427279,423010,405922,540307,904522,62183,764593,285070,239800,926059,1000340,1017638,293030,101217,525080,159532,100584,716046,409341,401549,965024,404257,568,678895,710087,660044,596959,741578,179249,853278,275786,645766,323058,85851,1011438,629387,197229,548673,1032883,304384,243183,526090,583502,30662,339118,689139,995787,572301,105858,523221,692539,455398,513412,798427,1012,867264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003911s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]