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` = 1013401 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013401 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420211,485248,110695,125773,563658,500239,793706,506249,196886,218531,1044370,172717,85290,787380,681018,627011,678711,603644,270687,984600,426940,520833,403944,16730,719155,724528,384259,709147,220930,933778,611709,218581,1001555,748703,983814,769984,140328,6931,787620,430933,294890,470257,115246,450982,526073,913420,24259,812807,606310,595281,1032734,472670,330918,597403,1012981,650019,674084,37661,448066,76292) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002678s ]