SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 353041 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 353041 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327245,548469,1021045,499736,690876,105025,268989,898194,319996,130205,378449,891315,877040,171624,453845,658147,463101,153664,395354,370041,623552,247172,99685,75430,761059,518332,733209,328247,716056,621819,423339,395831,300823,21361,1018264,119139,871250,600216,526723,120002,925054,135805,110107,340317,386351,919708,503776,198454,479719,545033,365540,559297,560803,360572,242414,1006099,724699,933353,622754,887400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 353041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 353041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001958s ]