SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003630s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200584 LIMIT 1 [ RunTime:0.003725s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200584 [ RunTime:0.005488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302085,714789,423912,633324,242928,613690,175408,873672,389469,578354,1011847,185180,904059,900474,873240,823210,455310,929214,271129,776589,952722,29221,384612,223457,69821,1004800,690037,492308,413530,479550,116182,854859,288300,645181,512309,1045004,651299,732628,782922,947445,47052,850482,876456,89301,653761,73446,564595,136222,327292,546886,294195,917989,342382,373745,737507,587800,82956,629195,587781,433279) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.050831s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001929s ]