SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438307 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438307 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (885105,633683,105353,377934,323676,435161,791676,554983,118894,904910,770391,584312,1040103,824615,115859,581299,730692,712582,200867,524143,350077,1032273,219426,255565,892988,592197,1021581,29273,744581,690644,491692,735029,236857,874385,849607,752348,219562,242274,896219,23838,347419,756648,74268,409965,172328,245032,544484,357929,60030,962550,729562,432764,412701,628654,325174,626612,400275,927442,479279,801579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]