SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38190 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38190 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118378,671035,710917,983613,163871,600236,748090,726885,282327,541358,1024102,250447,111484,643016,888905,314308,527228,456589,559236,278808,948459,259004,311322,220307,299841,987515,404447,270704,745667,930731,890811,660579,232654,248666,80063,604066,657261,234548,837187,17024,966103,940559,596879,660215,996593,167560,488027,239928,227953,1048273,35569,642459,598408,1004917,708465,679517,568694,319307,448982,419952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]