SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001919s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109506 LIMIT 1 [ RunTime:0.000579s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109506 [ RunTime:0.002394s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121053,251774,344485,263964,144538,84734,737725,554076,744628,223814,564129,1033450,418059,742958,184095,744241,617348,815448,932452,818432,585354,516509,692195,517822,606501,369378,288899,170717,1004275,649157,1030268,665769,630633,286617,761082,379102,572898,814587,109383,994347,291237,165118,312854,499679,274715,90764,481848,962264,670079,532078,53148,207689,102296,465030,321692,894670,68639,997978,144885,567948) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]