SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478080 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478080 [ RunTime:0.002015s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (777223,390179,742213,179050,347238,55883,953505,555181,142951,137947,793686,709265,293041,99022,794331,912508,325099,563651,624771,643165,638036,305307,657971,193461,810154,844000,345024,855010,305788,121360,38559,121932,376108,921196,773346,89617,462906,432698,263655,324452,876934,499898,244459,406535,425072,775558,263332,737170,602772,110755,337138,673804,878508,624679,223058,756330,396618,573819,731613,95902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001601s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]