SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549073 LIMIT 1 [ RunTime:0.000509s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549073 [ RunTime:0.002722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (164090,740572,575073,544925,730424,845829,746519,979418,789503,346305,916191,110732,116532,330546,76440,239964,14096,402198,618024,864769,166916,108985,518479,612442,838886,1030249,198612,938148,1026458,344001,311849,707787,386091,51327,227571,197207,44823,17351,848179,1015411,493481,658037,155558,828858,661320,254438,381231,658509,178808,807214,527738,960690,1046252,708178,977009,215357,1046871,815098,178907,622450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]