SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520147 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520147 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428923,521154,414793,932529,234439,451724,884733,814074,487047,392577,172690,545444,789297,805242,101203,732538,723562,958662,651453,5354,562885,1032658,674631,313592,902293,172332,800869,691203,157531,401928,185667,110103,543080,91844,232224,140801,646379,705946,944841,690128,558063,42553,872343,371999,956993,326053,449646,921733,914471,248328,468770,567400,336797,917147,590627,867071,288330,77514,459255,510721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520147 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520147 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]