SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548074 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548074 [ RunTime:0.002093s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (910738,903210,394720,675061,804008,239861,960031,958248,1042192,986782,680482,599665,496668,8976,73456,600722,155791,307067,909704,861685,369303,158690,843562,412377,858642,497026,988902,878275,739148,323361,108348,868929,991281,300783,17325,461292,741395,835426,648600,806885,575091,979546,514089,347294,173129,881007,648146,908791,993192,883517,996211,865721,617883,896902,827260,690538,704327,439189,905831,2880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548074 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548074 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]