SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 742583 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 742583 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (848600,128577,183794,94502,323490,214059,424689,962263,787627,930472,26850,794268,972598,457221,419632,319739,66044,926497,841906,275341,1011779,1006023,987835,1000678,539493,228301,322216,288807,162208,796513,65113,419796,843153,474651,258756,566362,13576,645964,440439,331688,312701,424943,295389,727397,326760,516212,156871,916865,566660,868598,284851,915787,48132,814900,17383,682505,739512,1887,479406,557935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 742583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 742583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]