SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532073 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532073 [ RunTime:0.002267s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (863455,257130,273121,456636,971066,235885,821849,271816,181928,901574,839013,851956,689614,43627,263689,648767,290089,513665,967703,87188,296044,249576,149112,634472,36689,168889,925309,289373,486949,652117,191770,975732,109189,98407,439715,1000913,925512,72064,476691,162607,472503,117609,29025,102271,451130,595455,136106,547168,361203,1001110,15934,178646,31791,393087,417180,722121,378011,340453,65461,174761) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]