SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043921 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043921 [ RunTime:0.001704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (279764,933037,204140,79621,118112,144088,627911,993633,698669,528142,49198,935840,377329,421644,130637,918086,717050,150239,190705,153337,690954,710724,419744,669634,1043359,901012,307038,942853,656623,1040847,715878,1048816,109960,880356,657827,329879,1039139,869254,291920,170833,252755,416259,115316,849621,215392,693647,174314,602116,744848,856285,940886,448792,6746,415196,554896,285053,924697,484960,155449,73116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043921 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043921 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]