SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019880 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019880 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813250,21603,123474,968918,471912,176937,294438,934539,24395,839223,218484,197156,791411,371473,837423,488088,324708,960480,521771,81240,775481,190440,96375,252103,819250,964509,152790,276321,663871,250386,511284,429922,308748,822611,558701,241687,327820,78054,855637,147746,116870,961380,203894,275192,434252,380812,96320,391288,425260,218577,850918,659369,475850,1039341,405784,272833,265579,604189,412420,715463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]