SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001684s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681501 LIMIT 1 [ RunTime:0.000704s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681501 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204144,139291,833738,946026,629579,677405,123205,212007,165019,433779,412614,965127,891227,752252,808545,909170,117492,314725,906609,218902,226009,331522,678576,881145,3882,1015603,253602,710613,338186,971419,418570,169348,153994,173695,172513,135251,784094,233169,277333,747513,892313,403363,994109,303682,740591,491277,188857,417683,983650,145435,850503,113101,249355,239138,671818,624183,369169,183491,607162,283766) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]