SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401071 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401071 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (859326,180207,698486,113934,376566,239278,122067,664794,920898,22215,685156,48199,241896,298147,83881,538808,522318,382407,835279,959438,56827,28393,492509,858194,989451,43396,82257,275105,131739,939682,34223,875372,223874,545426,662358,803061,483457,146752,428653,167675,529891,659245,937932,715347,480076,272781,632258,160341,1119,205396,44106,1045195,544651,943121,543376,313333,150240,470296,53217,102611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]