SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046200 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046200 [ RunTime:0.001513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385317,46756,401743,268817,849736,50482,261882,625564,91348,951079,527156,514431,152374,744784,827290,36877,200392,187682,315851,93330,849700,212967,232946,911080,342406,841526,1047771,46863,770421,82503,841413,54482,549772,451994,325271,689985,84541,647408,884698,139634,249316,993250,898161,185756,382550,997891,50777,627614,215289,870130,234885,750942,708112,108818,297616,144391,849866,787796,284262,560166) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]