SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026747 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026747 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (886633,889924,273366,580495,343881,534845,498636,202641,162830,150890,640486,637097,975307,897945,274214,462142,593207,366557,315169,150256,177564,189062,257519,490670,778065,468080,194493,805936,389955,102626,13643,851691,303109,608020,11130,35049,626621,186488,550594,202620,529304,985994,740160,677929,779460,448110,35033,942955,639425,801900,249999,417218,281299,1032736,812337,140097,990010,722907,159472,712279) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026747 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026747 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]