SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487829 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487829 [ RunTime:0.002561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125714,714380,551285,362300,989427,138862,306914,363830,902875,256724,755049,567176,743830,312240,883552,547424,60564,88649,114481,697221,265231,783274,1033117,305467,162411,900437,239692,793898,90188,534178,772869,757602,34957,1006788,596284,856028,1039986,896608,191518,204923,890898,739155,371228,580156,277622,535440,283248,917000,726302,973695,492710,540586,153743,776777,175822,445281,415313,600585,273292,22593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487829 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487829 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001062s ]