SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981628 LIMIT 1 [ RunTime:0.000463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981628 [ RunTime:0.001901s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (883308,1045633,581089,397355,427834,762634,177980,76995,501894,154603,424869,100718,716963,25428,164809,118606,566455,970829,220030,312632,291811,730644,591790,772856,223700,686230,591431,348190,36935,188226,587879,40784,546472,347022,844893,79933,329866,410180,980005,257500,223240,928556,833839,704054,211312,705541,685376,907960,150165,135009,1016180,271568,677899,914953,78480,10519,660304,30135,671755,969860) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000684s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000901s ]