SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490046 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490046 [ RunTime:0.002808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (742113,142161,61491,631385,589491,73814,91958,1012737,46766,884591,272955,444723,704121,691119,906217,473695,567359,682330,936655,186005,177559,380884,471757,601472,715407,369679,806443,146240,241762,55079,174622,604016,681361,696489,169276,876478,437348,814090,1033906,294428,392450,756130,796998,334299,48729,828532,747438,757008,922229,938851,1000752,409305,337046,7239,1943,305383,663665,901891,50624,313982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]