SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483731 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483731 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514182,324039,248961,143478,515751,882329,551512,439150,943628,975595,655984,930659,500816,582620,561760,79239,334857,982198,761501,717820,112159,92691,861792,811639,333738,1023564,597575,1036129,297390,986837,3288,190386,315460,836266,860897,250736,722420,609801,329530,964258,989455,869097,266369,170614,687866,932733,580593,901575,774885,924409,805708,716092,256674,742185,839226,296917,544350,31660,254676,638376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483731 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483731 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]