SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022504 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022504 [ RunTime:0.001793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50777,183292,17465,733073,490053,156464,112626,929958,797462,840547,241341,849785,903370,413698,494045,187635,826066,408037,297894,3635,504656,612068,94848,694560,351761,887215,882563,345128,424039,81258,530672,411643,128478,391541,30804,847946,594343,674682,764875,903625,307162,459049,407351,93458,6403,609095,189668,708938,254602,454770,352915,183084,1027128,431307,950674,19750,706031,546308,139069,43980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]