SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042017 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042017 [ RunTime:0.002811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191153,503370,14103,569507,1009829,666375,564202,985334,861780,149247,970889,226427,611350,780100,617084,788000,233456,639559,389890,853712,593414,87668,667889,469121,795005,416446,672106,220147,387608,542620,203011,841433,669010,789262,570339,538148,406367,305956,996546,708600,662049,249736,524205,228405,40619,188244,596464,742766,820036,797123,15189,88477,932862,485789,837212,846960,156330,183656,363579,232503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003670s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]