SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458310 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458310 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (895303,28461,633983,1022993,44128,908062,205802,528976,601445,175580,504384,239607,634105,537505,619021,561845,479460,972892,252932,472855,785400,630693,611278,548416,392706,10986,941208,624408,657687,815711,1037640,413532,918483,64279,903740,686826,57008,588334,614133,10769,631384,231807,739211,1026313,312835,243933,236552,531869,1011679,1012795,349695,674116,465115,415978,128177,328491,635273,1017828,162377,872011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000392s ]