SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 972583 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 972583 [ RunTime:0.002017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028128,651090,183127,831986,94321,329574,1001619,474517,436980,932216,820698,288813,277359,325978,562097,21780,33613,110554,603348,846279,592228,146136,897250,793102,464029,505217,646216,1020636,315359,577604,904913,810972,475547,362676,597614,855324,454072,712133,537325,304829,927959,52711,693604,246382,963224,879042,352347,892389,196068,586204,910355,238969,189451,47594,1642,447917,491680,1502,829649,487146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 972583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 972583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]