SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201905 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201905 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (306060,389647,797499,825637,637843,916734,346786,429255,371221,929574,406513,304396,626650,600845,994501,818559,101504,252994,417441,478034,317999,248808,930901,839229,221506,82239,316008,229126,474209,465100,369685,50427,76152,31445,943290,917796,773498,549633,38919,418698,307000,718756,326709,50262,152607,937306,277851,898848,447039,514165,813936,381616,171365,733198,592351,734533,663045,768697,544951,1008896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000386s ]