SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544851 LIMIT 1 [ RunTime:0.000573s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544851 [ RunTime:0.002578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808230,468722,373753,1008404,157860,81496,707971,311244,693329,348792,458059,820258,148742,48589,578317,154312,911723,862856,558961,233783,796775,454160,54433,558354,782993,724891,508609,705135,675395,826518,657339,876727,1020955,445446,667901,256554,416357,793544,23716,29597,914540,128782,250704,45164,60944,953600,216824,566030,514175,283023,327711,1016036,202681,929800,526744,623841,65303,440750,590197,366531) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]