SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 337210 LIMIT 1 [ RunTime:0.001591s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 337210 [ RunTime:0.001974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303178,181726,924577,983582,131483,295576,342993,574555,601999,521093,893070,267986,795559,849672,284961,890547,689212,196379,559388,263570,541715,837345,165145,248523,459501,765140,700015,823403,460877,772806,934954,114077,790451,500802,478762,362383,549383,1041844,140839,92966,558827,255111,916761,895345,302858,280697,316869,747691,338246,276106,171286,475325,352204,955179,945136,368339,768004,284232,399176,623953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 337210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 337210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002584s ]