SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001898s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 588043 LIMIT 1 [ RunTime:0.000592s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 588043 [ RunTime:0.004681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (462634,125556,250132,736772,174950,230169,343485,96611,1046742,84769,77951,463436,624474,736258,154194,500760,221641,980699,90411,166025,652359,57946,970521,135228,715273,51227,118367,209696,233204,612024,864744,885788,748393,150377,501906,72814,989405,976601,879175,494439,269527,584288,920100,596165,928998,761359,910287,378347,91372,137999,795337,763138,247768,980654,169632,376676,816288,347948,338738,887575) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 588043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 588043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000761s ]