SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415343 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415343 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (859168,923457,402577,514951,135962,284405,925628,954433,584800,60008,54109,530818,464642,452426,409987,239150,23509,350973,861185,189686,858540,958632,888090,927211,1032989,168680,95106,731897,884777,425419,284005,833737,585129,862388,490301,900223,401843,527003,198213,144690,1014199,253755,713314,340903,781326,255640,874807,458795,415405,610544,149844,815961,210284,976252,116833,859693,435035,718125,545732,613455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]